Profiling Report

Dataset statistics

Number of variables	9
Number of observations	11065619
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	629106
Duplicate rows (%)	5.7%
Total size in memory	844.2 MiB
Average record size in memory	80.0 B

Variable types

Numeric	9

Alerts

Dataset has 629106 (5.7%) duplicate rows	Duplicates
`voltage` is highly overall correlated with `current` and 2 other fields	High correlation
`current` is highly overall correlated with `voltage` and 2 other fields	High correlation
`workstation_cpu` is highly overall correlated with `voltage` and 2 other fields	High correlation
`workstation_ram` is highly overall correlated with `voltage` and 2 other fields	High correlation
`esp32_temperature` has 3061149 (27.7%) zeros	Zeros
`workstation_cpu` has 6764177 (61.1%) zeros	Zeros
`workstation_gpu` has 10793423 (97.5%) zeros	Zeros
`workstation_ram` has 6675954 (60.3%) zeros	Zeros

Reproduction

Analysis started	2023-07-25 11:39:32.232655
Analysis finished	2023-07-25 11:41:36.099410
Duration	2 minutes and 3.87 seconds
Software version	ydata-profiling vv4.3.2
Download configuration	config.json

voltage
Real number (ℝ)

HIGH CORRELATION

Distinct	43
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.02132

Minimum	116.1
Maximum	120.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	116.1
5-th percentile	119.6
Q1	120
median	120.1
Q3	120.1
95-th percentile	120.5
Maximum	120.6
Range	4.5
Interquartile range (IQR)	0.1

Descriptive statistics

Standard deviation	0.30542714
Coefficient of variation (CV)	0.0025447739
Kurtosis	16.340703
Mean	120.02132
Median Absolute Deviation (MAD)	0.1
Skewness	-3.4240325
Sum	1.3281102 × 10⁹
Variance	0.093285736
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
120	3497786	31.6%
120.1	3420896	30.9%
120.2	1675175	15.1%
119.9	976188	8.8%
120.5	579419	5.2%
119.6	353741	3.2%
119.8	96220	0.9%
118.3	86795	0.8%
118.9	85433	0.8%
120.4	66245	0.6%
Other values (33)	227721	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
116.1	3	< 0.1%
116.2	3	< 0.1%
116.5	1	< 0.1%
116.7	1	< 0.1%
116.8	4	< 0.1%
116.9	5	< 0.1%
117	10	< 0.1%
117.1	4	< 0.1%
117.2	7	< 0.1%
117.3	8	< 0.1%

Value	Count	Frequency (%)
120.6	788	< 0.1%
120.5	579419	5.2%
120.4	66245	0.6%
120.3	15	< 0.1%
120.2	1675175	15.1%
120.1	3420896	30.9%
120	3497786	31.6%
119.9	976188	8.8%
119.8	96220	0.9%
119.7	12005	0.1%

current
Real number (ℝ)

HIGH CORRELATION

Distinct	1092
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.82034394

Minimum	0.02
Maximum	2.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0.02
5-th percentile	0.13
Q1	0.68
median	0.92
Q3	0.94
95-th percentile	1.057
Maximum	2.1
Range	2.08
Interquartile range (IQR)	0.26

Descriptive statistics

Standard deviation	0.23061584
Coefficient of variation (CV)	0.28112091
Kurtosis	2.1688513
Mean	0.82034394
Median Absolute Deviation (MAD)	0.11
Skewness	-1.421553
Sum	9077613.5
Variance	0.053183665
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.92	1561932	14.1%
0.93	1446578	13.1%
0.62	1101668	10.0%
0.94	813172	7.3%
0.13	640347	5.8%
0.61	639726	5.8%
0.69	411616	3.7%
1.03	292740	2.6%
1.04	275381	2.5%
1.02	257373	2.3%
Other values (1082)	3625086	32.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02	5995	0.1%
0.09	85	< 0.1%
0.1	2	< 0.1%
0.11	4	< 0.1%
0.12	10	< 0.1%
0.13	640347	5.8%
0.16	3	< 0.1%
0.19	2	< 0.1%
0.21	1	< 0.1%
0.22	2	< 0.1%

Value	Count	Frequency (%)
2.1	4	< 0.1%
2.09	3	< 0.1%
2.08	1	< 0.1%
1.98	1	< 0.1%
1.976	1	< 0.1%
1.957	1	< 0.1%
1.944	1	< 0.1%
1.94	3	< 0.1%
1.93	5	< 0.1%
1.928	2	< 0.1%

frequency
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59.96468

Minimum	59.3
Maximum	60.3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	59.3
5-th percentile	59.9
Q1	59.9
median	60
Q3	60
95-th percentile	60
Maximum	60.3
Range	1
Interquartile range (IQR)	0.1

Descriptive statistics

Standard deviation	0.049704949
Coefficient of variation (CV)	0.00082890377
Kurtosis	-0.7624344
Mean	59.96468
Median Absolute Deviation (MAD)	0
Skewness	-0.82633497
Sum	6.635463 × 10⁸
Variance	0.002470582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
60	7250525	65.5%
59.9	3712301	33.5%
59.8	99556	0.9%
60.1	3170	< 0.1%
59.7	46	< 0.1%
60.2	18	< 0.1%
60.3	1	< 0.1%
59.3	1	< 0.1%
59.4	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
59.3	1	< 0.1%
59.4	1	< 0.1%
59.7	46	< 0.1%
59.8	99556	0.9%
59.9	3712301	33.5%
60	7250525	65.5%
60.1	3170	< 0.1%
60.2	18	< 0.1%
60.3	1	< 0.1%

Value	Count	Frequency (%)
60.3	1	< 0.1%
60.2	18	< 0.1%
60.1	3170	< 0.1%
60	7250525	65.5%
59.9	3712301	33.5%
59.8	99556	0.9%
59.7	46	< 0.1%
59.4	1	< 0.1%
59.3	1	< 0.1%

energy
Real number (ℝ)

Distinct	45882
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.39697

Minimum	0
Maximum	442.626
Zeros	82
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	6.46
Q1	38.31
median	119.99
Q3	173.52
95-th percentile	276.77
Maximum	442.626
Range	442.626
Interquartile range (IQR)	135.21

Descriptive statistics

Standard deviation	98.100056
Coefficient of variation (CV)	0.80149087
Kurtosis	1.4894105
Mean	122.39697
Median Absolute Deviation (MAD)	72.76
Skewness	1.1365584
Sum	1.3543983 × 10⁹
Variance	9623.6209
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
137.1	7730	0.1%
137.43	7723	0.1%
136.99	7720	0.1%
137.24	7719	0.1%
137.29	7719	0.1%
136.93	7718	0.1%
137.07	7717	0.1%
136.6	7716	0.1%
136.85	7715	0.1%
136.49	7714	0.1%
Other values (45872)	10988428	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	82	< 0.1%
0.02	570	< 0.1%
0.03	687	< 0.1%
0.04	678	< 0.1%
0.05	760	< 0.1%
0.06	704	< 0.1%
0.07	638	< 0.1%
0.08	651	< 0.1%
0.09	759	< 0.1%
0.1	686	< 0.1%

Value	Count	Frequency (%)
442.626	13	< 0.1%
442.625	31	< 0.1%
442.624	25	< 0.1%
442.623	31	< 0.1%
442.622	26	< 0.1%
442.621	29	< 0.1%
442.62	31	< 0.1%
442.619	25	< 0.1%
442.618	30	< 0.1%
442.617	25	< 0.1%

power_factor
Real number (ℝ)

Distinct	57
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.86025335

Minimum	0
Maximum	1
Zeros	6074
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0.32
Q1	0.86
median	0.89
Q3	0.9
95-th percentile	0.97
Maximum	1
Range	1
Interquartile range (IQR)	0.04

Descriptive statistics

Standard deviation	0.13945405
Coefficient of variation (CV)	0.16210811
Kurtosis	10.851852
Mean	0.86025335
Median Absolute Deviation (MAD)	0.03
Skewness	-3.4260506
Sum	9519235.8
Variance	0.019447431
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.86	3253719	29.4%
0.9	2399702	21.7%
0.89	1296058	11.7%
0.94	678932	6.1%
0.32	609354	5.5%
0.97	538312	4.9%
0.85	391609	3.5%
0.95	361836	3.3%
0.87	328359	3.0%
0.91	299376	2.7%
Other values (47)	908362	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6074	0.1%
0.03	4	< 0.1%
0.04	1	< 0.1%
0.07	1	< 0.1%
0.09	1	< 0.1%
0.1	1	< 0.1%
0.17	1	< 0.1%
0.19	2	< 0.1%
0.21	1	< 0.1%
0.27	1	< 0.1%

Value	Count	Frequency (%)
1	903	< 0.1%
0.99	303	< 0.1%
0.98	35033	0.3%
0.97	538312	4.9%
0.96	156648	1.4%
0.95	361836	3.3%
0.94	678932	6.1%
0.93	298199	2.7%
0.92	248311	2.2%
0.91	299376	2.7%

esp32_temperature
Real number (ℝ)

ZEROS

Distinct	87
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.100912

Minimum	0
Maximum	53.3333
Zeros	3061149
Zeros (%)	27.7%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	31.67
Q3	33.89
95-th percentile	53.3333
Maximum	53.3333
Range	53.3333
Interquartile range (IQR)	33.89

Descriptive statistics

Standard deviation	15.987543
Coefficient of variation (CV)	0.66335841
Kurtosis	-0.83834116
Mean	24.100912
Median Absolute Deviation (MAD)	4.45
Skewness	-0.47949705
Sum	2.6669151 × 10⁸
Variance	255.60153
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3061149	27.7%
33.89	1957975	17.7%
33.33	1318189	11.9%
34.44	669242	6.0%
53.3333	660831	6.0%
26.67	580106	5.2%
27.22	517443	4.7%
32.78	413152	3.7%
26.11	358328	3.2%
32.22	335751	3.0%
Other values (77)	1193453	10.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3061149	27.7%
20.5556	1	< 0.1%
20.56	1	< 0.1%
21.1111	1	< 0.1%
21.6667	2	< 0.1%
21.67	13	< 0.1%
22.22	774	< 0.1%
22.2222	3	< 0.1%
22.78	23626	0.2%
23.33	21378	0.2%

Value	Count	Frequency (%)
53.3333	660831	6.0%
52.7778	51	< 0.1%
52.2222	74	< 0.1%
51.6667	56	< 0.1%
51.1111	55	< 0.1%
50.5556	64	< 0.1%
50	61	< 0.1%
49.4444	42	< 0.1%
48.8889	61	< 0.1%
48.3333	51	< 0.1%

workstation_cpu
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2696
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9972231

Minimum	0
Maximum	100
Zeros	6764177
Zeros (%)	61.1%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4.43
95-th percentile	8.85
Maximum	100
Range	100
Interquartile range (IQR)	4.43

Descriptive statistics

Standard deviation	3.3134864
Coefficient of variation (CV)	1.6590467
Kurtosis	8.2015163
Mean	1.9972231
Median Absolute Deviation (MAD)	0
Skewness	2.0132835
Sum	22100510
Variance	10.979192
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6764177	61.1%
0.1	187572	1.7%
0.2	177318	1.6%
0.3	145380	1.3%
4.43	129114	1.2%
4.3	101019	0.9%
0.4	98748	0.9%
4.56	90528	0.8%
4.36	88841	0.8%
4.49	82023	0.7%
Other values (2686)	3200899	28.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6764177	61.1%
0.1	187572	1.7%
0.2	177318	1.6%
0.26	1	< 0.1%
0.3	145380	1.3%
0.4	98748	0.9%
0.5	52733	0.5%
0.6	29489	0.3%
0.7	11675	0.1%
0.8	8304	0.1%

Value	Count	Frequency (%)
100	6	< 0.1%
99.8	5	< 0.1%
99.62	1	< 0.1%
99.09	1	< 0.1%
98.6	4	< 0.1%
97.53	1	< 0.1%
96.74	1	< 0.1%
96.61	1	< 0.1%
96.22	2	< 0.1%
95.44	1	< 0.1%

workstation_gpu
Real number (ℝ)

ZEROS

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.035774151

Minimum	0
Maximum	63
Zeros	10793423
Zeros (%)	97.5%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	63
Range	63
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.31441047
Coefficient of variation (CV)	8.7887611
Kurtosis	928.91307
Mean	0.035774151
Median Absolute Deviation (MAD)	0
Skewness	19.8574
Sum	395863.13
Variance	0.098853944
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10793423	97.5%
1	179570	1.6%
2	33668	0.3%
3	18130	0.2%
0.01	17904	0.2%
4	7229	0.1%
5	4581	< 0.1%
0.02	2359	< 0.1%
6	2194	< 0.1%
0.03	1987	< 0.1%
Other values (42)	4574	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10793423	97.5%
0.01	17904	0.2%
0.02	2359	< 0.1%
0.03	1987	< 0.1%
0.04	666	< 0.1%
0.05	285	< 0.1%
0.06	142	< 0.1%
0.07	149	< 0.1%
0.08	81	< 0.1%
0.09	48	< 0.1%

Value	Count	Frequency (%)
63	1	< 0.1%
57	1	< 0.1%
40	2	< 0.1%
34	1	< 0.1%
30	4	< 0.1%
29	3	< 0.1%
28	7	< 0.1%
26	7	< 0.1%
25	8	< 0.1%
24	3	< 0.1%

workstation_ram
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	3560
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.779082

Minimum	0
Maximum	55.2
Zeros	6675954
Zeros (%)	60.3%
Negative	0
Negative (%)	0.0%
Memory size	168.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	37.21
95-th percentile	44.11
Maximum	55.2
Range	55.2
Interquartile range (IQR)	37.21

Descriptive statistics

Standard deviation	18.691217
Coefficient of variation (CV)	1.2647075
Kurtosis	-1.5639621
Mean	14.779082
Median Absolute Deviation (MAD)	0
Skewness	0.55196455
Sum	1.635397 × 10⁸
Variance	349.36159
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6675954	60.3%
42.5	25973	0.2%
42.7	22949	0.2%
47.5	21099	0.2%
44.3	20924	0.2%
47.4	20756	0.2%
38.95	20305	0.2%
38.96	20194	0.2%
45.9	20136	0.2%
42.3	20102	0.2%
Other values (3550)	4197227	37.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6675954	60.3%
11.37	1	< 0.1%
11.38	40	< 0.1%
11.39	29	< 0.1%
11.4	161	< 0.1%
11.41	62	< 0.1%
11.42	15	< 0.1%
11.43	56	< 0.1%
11.44	21	< 0.1%
11.45	45	< 0.1%

Value	Count	Frequency (%)
55.2	4	< 0.1%
55.1	10	< 0.1%
55	17	< 0.1%
54.9	21	< 0.1%
54.8	4	< 0.1%
54.7	10	< 0.1%
54.6	8	< 0.1%
54.5	13	< 0.1%
54.3	12	< 0.1%
54.2	14	< 0.1%

Auto

Heatmap
Table

	voltage	current	frequency	energy	power_factor	esp32_temperature	workstation_cpu	workstation_gpu	workstation_ram
voltage	1.000	-0.821	0.121	0.008	-0.188	0.152	-0.606	-0.133	-0.567
current	-0.821	1.000	-0.006	-0.045	-0.028	-0.298	0.572	0.092	0.598
frequency	0.121	-0.006	1.000	0.018	0.008	0.014	0.006	0.005	0.011
energy	0.008	-0.045	0.018	1.000	0.464	0.394	0.441	0.090	0.449
power_factor	-0.188	-0.028	0.008	0.464	1.000	0.372	0.436	0.136	0.262
esp32_temperature	0.152	-0.298	0.014	0.394	0.372	1.000	0.227	0.159	0.220
workstation_cpu	-0.606	0.572	0.006	0.441	0.436	0.227	1.000	0.264	0.886
workstation_gpu	-0.133	0.092	0.005	0.090	0.136	0.159	0.264	1.000	0.190
workstation_ram	-0.567	0.598	0.011	0.449	0.262	0.220	0.886	0.190	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	voltage	current	frequency	energy	power_factor	esp32_temperature	workstation_cpu	workstation_gpu	workstation_ram
fecha_servidor
2021-05-05 22:05:27	119.9	1.15	60.0	0.0	0.92	0.0	0.0	0.0	0.0
2021-05-05 22:05:28	119.9	1.15	60.0	0.0	0.92	0.0	0.0	0.0	0.0
2021-05-05 22:05:28	119.9	1.09	60.0	0.0	0.91	0.0	0.0	0.0	0.0
2021-05-05 22:05:29	119.9	1.09	60.0	0.0	0.91	0.0	0.0	0.0	0.0
2021-05-05 22:05:29	120.0	1.01	60.0	0.0	0.89	0.0	0.0	0.0	0.0
2021-05-05 22:05:30	120.0	1.01	60.0	0.0	0.89	0.0	0.0	0.0	0.0
2021-05-05 22:05:30	120.0	0.96	60.0	0.0	0.87	0.0	0.0	0.0	0.0
2021-05-05 22:05:31	120.0	0.96	60.0	0.0	0.87	0.0	0.0	0.0	0.0
2021-05-05 22:05:32	120.0	1.00	60.0	0.0	0.88	0.0	0.0	0.0	0.0
2021-05-05 22:05:33	120.0	0.97	60.0	0.0	0.88	0.0	0.0	0.0	0.0

	voltage	current	frequency	energy	power_factor	esp32_temperature	workstation_cpu	workstation_gpu	workstation_ram
fecha_servidor
2021-12-04 08:18:08	118.8	0.701	59.9	24.850	0.96	53.3333	5.21	0.0	24.95
2021-12-04 08:18:08	119.6	1.047	59.9	442.626	0.89	53.3333	13.69	0.0	48.56
2021-12-04 08:18:08	119.6	1.031	59.9	442.626	0.90	53.3333	7.54	0.0	48.55
2021-12-04 08:18:09	118.8	0.707	59.9	24.850	0.97	53.3333	5.26	0.0	24.95
2021-12-04 08:18:09	119.6	1.152	60.0	442.626	0.91	53.3333	5.77	0.0	48.55
2021-12-04 08:18:10	118.8	0.712	59.9	24.850	0.97	53.3333	5.08	0.0	24.95
2021-12-04 08:18:11	118.9	0.675	59.9	24.850	0.98	53.3333	5.21	0.0	24.94
2021-12-04 08:18:11	119.6	1.189	59.9	442.626	0.92	53.3333	13.18	0.0	48.58
2021-12-04 08:18:11	119.6	1.152	59.9	442.626	0.91	53.3333	13.18	0.0	48.58
2021-12-04 08:18:12	118.8	0.691	59.9	24.850	0.97	53.3333	4.43	0.0	24.95

Most frequently occurring

	voltage	current	frequency	energy	power_factor	esp32_temperature	# duplicates
628438	120.5	0.13	60.0	136.62	0.32	34.44	4669
628457	120.5	0.13	60.0	136.65	0.32	34.44	4543
628525	120.5	0.13	60.0	136.77	0.32	34.44	4316
628445	120.5	0.13	60.0	136.63	0.32	34.44	4277
628520	120.5	0.13	60.0	136.76	0.32	34.44	4213
628801	120.5	0.13	60.0	137.12	0.32	33.89	4210
628726	120.5	0.13	60.0	137.02	0.32	34.44	4150
628462	120.5	0.13	60.0	136.66	0.32	34.44	4099
628838	120.5	0.13	60.0	137.21	0.32	33.89	4081
628536	120.5	0.13	60.0	136.79	0.32	33.89	4074

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring